Understanding Relational Algebra Terms Practice Quiz Answer

Hello Friends in this article i am gone to share Coursera Course: Understanding Relational Algebra Terms Practice Quiz Answer with you.. | The Structured Query Language (SQL)

Understanding Relational Algebra Terms

Question 1)

Select the Relational Algebra term that matches the description in the question.

Associates every row from one relation with every row from another relation, basically multiplying the two relations. 

• Product
• Natural Join
• Projection 
• Selection 
• Union 

Question 2)

Select the Relational Algebra term that matches the description in the question.

Creates an answer set that matches rows from multiple relations using a common key. 

• Natural Join
• Product
• Projection
• Selection
• Union

Question 3)

Select the Relational Algebra term that matches the description in the question.

Creates an answer set that contains a subset of ROWS from the input relation. 

• Projection
• Natural Join
• Union
• Product
• Selection

Question 4)

Select the Relational Algebra term that matches the description in the question.

Creates an answer set that contains a subset of COLUMNS from the input relation. 

• Union
• Natural Join
• Product
• Projection
• Selection

Question 5)

Select the Relational Algebra term that matches the description in the question.

Creates an answer set that concatenates two similar relations together.

• Selection
• Product
• Natural Join
• Projection
• Union